Reporte estadístico

Dataset statistics

Number of variables	16
Number of observations	180
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	42.9 KiB
Average record size in memory	244.2 B

Variable types

Categorical	6
Numeric	10

Dataset

Description	Este es un analisis preeliminar para comprender de mejor forma los datos de nuestro dataset
Author	Kenneth David Leonel Triana , Juan Jose Naranjo, Alejandro Mora
URL	https://github.com/kennethLeonel/Monografia-calidad-del-aire-valle-de-aburra

Alerts

`anio` has constant value "2024"	Constant
`festivo` is highly imbalanced (71.4%)	Imbalance
`codigoserial` is uniformly distributed	Uniform
`estacion` is uniformly distributed	Uniform
`presion` has 57 (31.7%) zeros	Zeros
`p1` has 63 (35.0%) zeros	Zeros

Reproduction

Analysis started	2024-10-15 00:06:31.066005
Analysis finished	2024-10-15 00:06:49.696649
Duration	18.63 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

anio
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	12.1 KiB

2024	180

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	720
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2024
2nd row	2024
3rd row	2024
4th row	2024
5th row	2024

Common Values

Value	Count	Frequency (%)
2024	180	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2024	180	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	360	50.0%
0	180	25.0%
4	180	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	720	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	360	50.0%
0	180	25.0%
4	180	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	720	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	360	50.0%
0	180	25.0%
4	180	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	720	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	360	50.0%
0	180	25.0%
4	180	25.0%

mes
Categorical

Distinct	2
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	11.6 KiB

3	93
2	87

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
3	93	51.7%
2	87	48.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	93	51.7%
2	87	48.3%

Most occurring characters

Value	Count	Frequency (%)
3	93	51.7%
2	87	48.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	180	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	93	51.7%
2	87	48.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	180	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	93	51.7%
2	87	48.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	180	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	93	51.7%
2	87	48.3%

dia
Real number (ℝ)

Distinct	31
Distinct (%)	17.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.516667

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15.5
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7084849
Coefficient of variation (CV)	0.56123426
Kurtosis	-1.1864689
Mean	15.516667
Median Absolute Deviation (MAD)	7.5
Skewness	0.011522316
Sum	2793
Variance	75.837709
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	6	3.3%
2	6	3.3%
29	6	3.3%
28	6	3.3%
27	6	3.3%
26	6	3.3%
25	6	3.3%
24	6	3.3%
23	6	3.3%
22	6	3.3%
Other values (21)	120	66.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	3.3%
2	6	3.3%
3	6	3.3%
4	6	3.3%
5	6	3.3%
6	6	3.3%
7	6	3.3%
8	6	3.3%
9	6	3.3%
10	6	3.3%

Value	Count	Frequency (%)
31	3	1.7%
30	3	1.7%
29	6	3.3%
28	6	3.3%
27	6	3.3%
26	6	3.3%
25	6	3.3%
24	6	3.3%
23	6	3.3%
22	6	3.3%

pm25
Real number (ℝ)

Distinct	179
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	398.91051

Minimum	-1235.5337
Maximum	16692.348
Zeros	0
Zeros (%)	0.0%
Negative	10
Negative (%)	5.6%
Memory size	2.8 KiB

Quantile statistics

Minimum	-1235.5337
5-th percentile	-389.33758
Q1	21.115891
median	29.484673
Q3	36.236144
95-th percentile	4185.2472
Maximum	16692.348
Range	17927.882
Interquartile range (IQR)	15.120253

Descriptive statistics

Standard deviation	1867.3281
Coefficient of variation (CV)	4.6810701
Kurtosis	42.74711
Mean	398.91051
Median Absolute Deviation (MAD)	7.6909042
Skewness	5.9999492
Sum	71803.892
Variance	3486914.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36.04166667	2	1.1%
20.46693333	1	0.6%
-395.235265	1	0.6%
19.12517083	1	0.6%
-814.26774	1	0.6%
22.30719125	1	0.6%
23.05252042	1	0.6%
26.29606667	1	0.6%
26.01087083	1	0.6%
18.8345425	1	0.6%
Other values (169)	169	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1235.533741	1	0.6%
-1234.117461	1	0.6%
-821.8938267	1	0.6%
-820.9419133	1	0.6%
-814.26774	1	0.6%
-402.1138379	1	0.6%
-401.103565	1	0.6%
-395.235265	1	0.6%
-391.8376	1	0.6%
-389.2060042	1	0.6%

Value	Count	Frequency (%)
16692.34784	1	0.6%
12510.25325	1	0.6%
7524.074892	1	0.6%
4206.857683	1	0.6%
4202.691975	1	0.6%
4197.800408	1	0.6%
4197.21365	1	0.6%
4195.172246	1	0.6%
4188.727058	1	0.6%
4185.064037	1	0.6%

codigoserial
Categorical

UNIFORM

Distinct	3
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	11.8 KiB

28	60
69	60
86	60

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	360
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	28
2nd row	28
3rd row	28
4th row	28
5th row	28

Common Values

Value	Count	Frequency (%)
28	60	33.3%
69	60	33.3%
86	60	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
28	60	33.3%
69	60	33.3%
86	60	33.3%

Most occurring characters

Value	Count	Frequency (%)
8	120	33.3%
6	120	33.3%
2	60	16.7%
9	60	16.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	360	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
8	120	33.3%
6	120	33.3%
2	60	16.7%
9	60	16.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	360	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
8	120	33.3%
6	120	33.3%
2	60	16.7%
9	60	16.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	360	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
8	120	33.3%
6	120	33.3%
2	60	16.7%
9	60	16.7%

dia_semana
Categorical

Distinct	7
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Memory size	12.6 KiB

Jueves	27
Viernes	27
Sabado	27
Domingo	27
Lunes	24
Other values (2)	48

Length

Max length	9
Median length	7
Mean length	6.5666667
Min length	5

Characters and Unicode

Total characters	1182
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jueves
2nd row	Viernes
3rd row	Sabado
4th row	Domingo
5th row	Lunes

Common Values

Value	Count	Frequency (%)
Jueves	27	15.0%
Viernes	27	15.0%
Sabado	27	15.0%
Domingo	27	15.0%
Lunes	24	13.3%
Martes	24	13.3%
Miercoles	24	13.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
jueves	27	15.0%
viernes	27	15.0%
sabado	27	15.0%
domingo	27	15.0%
lunes	24	13.3%
martes	24	13.3%
miercoles	24	13.3%

Most occurring characters

Value	Count	Frequency (%)
e	204	17.3%
s	126	10.7%
o	105	8.9%
i	78	6.6%
n	78	6.6%
a	78	6.6%
r	75	6.3%
u	51	4.3%
M	48	4.1%
J	27	2.3%
Other values (12)	312	26.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1182	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	204	17.3%
s	126	10.7%
o	105	8.9%
i	78	6.6%
n	78	6.6%
a	78	6.6%
r	75	6.3%
u	51	4.3%
M	48	4.1%
J	27	2.3%
Other values (12)	312	26.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1182	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	204	17.3%
s	126	10.7%
o	105	8.9%
i	78	6.6%
n	78	6.6%
a	78	6.6%
r	75	6.3%
u	51	4.3%
M	48	4.1%
J	27	2.3%
Other values (12)	312	26.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1182	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	204	17.3%
s	126	10.7%
o	105	8.9%
i	78	6.6%
n	78	6.6%
a	78	6.6%
r	75	6.3%
u	51	4.3%
M	48	4.1%
J	27	2.3%
Other values (12)	312	26.4%

estacion
Categorical

UNIFORM

Distinct	3
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	14.2 KiB

Estacion Itagui	60
Estacion Caldas	60
Estacion Aranjuez	60

Length

Max length	17
Median length	15
Mean length	15.666667
Min length	15

Characters and Unicode

Total characters	2820
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Estacion Itagui
2nd row	Estacion Itagui
3rd row	Estacion Itagui
4th row	Estacion Itagui
5th row	Estacion Itagui

Common Values

Value	Count	Frequency (%)
Estacion Itagui	60	33.3%
Estacion Caldas	60	33.3%
Estacion Aranjuez	60	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
estacion	180	50.0%
itagui	60	16.7%
caldas	60	16.7%
aranjuez	60	16.7%

Most occurring characters

Value	Count	Frequency (%)
a	420	14.9%
t	240	8.5%
i	240	8.5%
n	240	8.5%
s	240	8.5%
E	180	6.4%
c	180	6.4%
o	180	6.4%
	180	6.4%
u	120	4.3%
Other values (10)	600	21.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2820	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	420	14.9%
t	240	8.5%
i	240	8.5%
n	240	8.5%
s	240	8.5%
E	180	6.4%
c	180	6.4%
o	180	6.4%
	180	6.4%
u	120	4.3%
Other values (10)	600	21.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2820	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	420	14.9%
t	240	8.5%
i	240	8.5%
n	240	8.5%
s	240	8.5%
E	180	6.4%
c	180	6.4%
o	180	6.4%
	180	6.4%
u	120	4.3%
Other values (10)	600	21.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2820	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	420	14.9%
t	240	8.5%
i	240	8.5%
n	240	8.5%
s	240	8.5%
E	180	6.4%
c	180	6.4%
o	180	6.4%
	180	6.4%
u	120	4.3%
Other values (10)	600	21.3%

festivo
Categorical

IMBALANCE

Distinct	2
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	11.6 KiB

0	171
1	9

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	171	95.0%
1	9	5.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	171	95.0%
1	9	5.0%

Most occurring characters

Value	Count	Frequency (%)
0	171	95.0%
1	9	5.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	180	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	171	95.0%
1	9	5.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	180	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	171	95.0%
1	9	5.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	180	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	171	95.0%
1	9	5.0%

temperatura
Real number (ℝ)

Distinct	171
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-37.432939

Minimum	-999
Maximum	25.805556
Zeros	0
Zeros (%)	0.0%
Negative	13
Negative (%)	7.2%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	21.149672
median	22.569056
Q3	24.01053
95-th percentile	25.146597
Maximum	25.805556
Range	1024.8056
Interquartile range (IQR)	2.8608577

Descriptive statistics

Standard deviation	236.97162
Coefficient of variation (CV)	-6.3305643
Kurtosis	12.689623
Mean	-37.432939
Median Absolute Deviation (MAD)	1.4451632
Skewness	-3.7976194
Sum	-6737.929
Variance	56155.551
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-999	10	5.6%
21.20336811	1	0.6%
22.43326389	1	0.6%
-487.1159722	1	0.6%
21.16861111	1	0.6%
22.01006944	1	0.6%
21.27694444	1	0.6%
21.59708333	1	0.6%
21.754375	1	0.6%
22.10930556	1	0.6%
Other values (161)	161	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-487.1159722	1	0.6%
-30.52168743	1	0.6%
-2.906805556	1	0.6%
13.58625	1	0.6%
17.50569444	1	0.6%
17.86701389	1	0.6%
18.04083333	1	0.6%
18.73861111	1	0.6%
18.8175	1	0.6%

Value	Count	Frequency (%)
25.80555556	1	0.6%
25.52388889	1	0.6%
25.51756944	1	0.6%
25.50707636	1	0.6%
25.49993056	1	0.6%
25.49090278	1	0.6%
25.42810416	1	0.6%
25.39229167	1	0.6%
25.38145833	1	0.6%
25.13423608	1	0.6%

humedad
Real number (ℝ)

Distinct	171
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7089607

Minimum	-999
Maximum	84.515444
Zeros	0
Zeros (%)	0.0%
Negative	11
Negative (%)	6.1%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	60.754462
median	67.10941
Q3	74.028226
95-th percentile	79.726716
Maximum	84.515444
Range	1083.5154
Interquartile range (IQR)	13.273764

Descriptive statistics

Standard deviation	247.62645
Coefficient of variation (CV)	43.375049
Kurtosis	12.680085
Mean	5.7089607
Median Absolute Deviation (MAD)	6.7010069
Skewness	-3.7943879
Sum	1027.6129
Variance	61318.859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-999	10	5.6%
84.51544444	1	0.6%
74.615	1	0.6%
-457.6452083	1	0.6%
82.33111111	1	0.6%
77.93104167	1	0.6%
77.36708333	1	0.6%
74.94527778	1	0.6%
73.88020833	1	0.6%
71.14763889	1	0.6%
Other values (161)	161	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-457.6452083	1	0.6%
17.6589931	1	0.6%
31.39416667	1	0.6%
54.21333333	1	0.6%
54.94104167	1	0.6%
55.531875	1	0.6%
55.66118056	1	0.6%
56.40430556	1	0.6%
56.65270833	1	0.6%

Value	Count	Frequency (%)
84.51544444	1	0.6%
84.4698125	1	0.6%
83.79554867	1	0.6%
83.44047228	1	0.6%
82.77643755	1	0.6%
82.33111111	1	0.6%
81.34544446	1	0.6%
80.49526392	1	0.6%
79.72923611	1	0.6%
79.7265833	1	0.6%

presion
Real number (ℝ)

ZEROS

Distinct	114
Distinct (%)	63.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	451.74671

Minimum	-999
Maximum	853.8609
Zeros	57
Zeros (%)	31.7%
Negative	14
Negative (%)	7.8%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	0
median	825.43719
Q3	850.27476
95-th percentile	852.5442
Maximum	853.8609
Range	1852.8609
Interquartile range (IQR)	850.27476

Descriptive statistics

Standard deviation	528.43086
Coefficient of variation (CV)	1.1697503
Kurtosis	0.60645694
Mean	451.74671
Median Absolute Deviation (MAD)	26.514375
Skewness	-1.1449589
Sum	81314.407
Variance	279239.17
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57	31.7%
-999	10	5.6%
-1.3875	2	1.1%
852.4464583	1	0.6%
850.2206944	1	0.6%
850.9357639	1	0.6%
851.6726389	1	0.6%
853.2250694	1	0.6%
853.8609028	1	0.6%
852.475625	1	0.6%
Other values (104)	104	57.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-80.75256944	1	0.6%
-52.03125	1	0.6%
-1.3875	2	1.1%
0	57	31.7%
798.1502778	1	0.6%
814.9458333	1	0.6%
824.0225	1	0.6%
824.0748611	1	0.6%
824.114375	1	0.6%

Value	Count	Frequency (%)
853.8609028	1	0.6%
853.2250694	1	0.6%
853.1511806	1	0.6%
853.0895139	1	0.6%
852.8140972	1	0.6%
852.7811806	1	0.6%
852.7346528	1	0.6%
852.681875	1	0.6%
852.6081944	1	0.6%
852.5408333	1	0.6%

p1
Real number (ℝ)

ZEROS

Distinct	50
Distinct (%)	27.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-116.92111

Minimum	-999
Maximum	0.064527778
Zeros	63
Zeros (%)	35.0%
Negative	41
Negative (%)	22.8%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	0
median	0
Q3	0.00014409722
95-th percentile	0.017636806
Maximum	0.064527778
Range	999.06453
Interquartile range (IQR)	0.00014409722

Descriptive statistics

Standard deviation	317.05482
Coefficient of variation (CV)	-2.7116987
Kurtosis	3.9114326
Mean	-116.92111
Median Absolute Deviation (MAD)	5.2083333 × 10^-5
Skewness	-2.408165
Sum	-21045.8
Variance	100523.76
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	63	35.0%
-999	20	11.1%
1.388888889 × 10^-5	12	6.7%
6.944444444 × 10^-6	10	5.6%
0.001791666667	3	1.7%
0.000125	3	1.7%
3.472222222 × 10^-5	3	1.7%
0.009680555556	2	1.1%
0.002388888889	2	1.1%
0.007159722222	2	1.1%
Other values (40)	60	33.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	20	11.1%
-496.725	2	1.1%
-27.75	1	0.6%
-6.243708333	2	1.1%
-6.242159722	1	0.6%
-5.549923611	1	0.6%
-4.1625	1	0.6%
-2.08125	1	0.6%
-2.081243056	1	0.6%
-2.079875	1	0.6%

Value	Count	Frequency (%)
0.06452777778	2	1.1%
0.04209027778	2	1.1%
0.03158333333	2	1.1%
0.02457638889	1	0.6%
0.02313888889	2	1.1%
0.01734722222	2	1.1%
0.01594444444	1	0.6%
0.01265277778	2	1.1%
0.009680555556	2	1.1%
0.007159722222	2	1.1%

velocidad_prom
Real number (ℝ)

Distinct	171
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-57.11957

Minimum	-999
Maximum	3.4436111
Zeros	0
Zeros (%)	0.0%
Negative	20
Negative (%)	11.1%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	1.5083333
median	1.790691
Q3	2.0823125
95-th percentile	2.5759441
Maximum	3.4436111
Range	1002.4436
Interquartile range (IQR)	0.57397917

Descriptive statistics

Standard deviation	232.09903
Coefficient of variation (CV)	-4.0633889
Kurtosis	12.694335
Mean	-57.11957
Median Absolute Deviation (MAD)	0.29175347
Skewness	-3.798311
Sum	-10281.523
Variance	53869.959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-999	10	5.6%
1.911458333	1	0.6%
1.887013889	1	0.6%
-496.1823611	1	0.6%
1.655555556	1	0.6%
1.480625	1	0.6%
1.349027778	1	0.6%
0.776875	1	0.6%
1.023055556	1	0.6%
1.302777778	1	0.6%
Other values (161)	161	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-496.1823611	1	0.6%
-49.77319444	1	0.6%
-25.90798611	1	0.6%
-4.976111111	1	0.6%
-4.195416667	1	0.6%
-2.930625	1	0.6%
-2.375486111	1	0.6%
-0.23	1	0.6%
-0.211875	1	0.6%

Value	Count	Frequency (%)
3.443611111	1	0.6%
3.122361111	1	0.6%
3.025694444	1	0.6%
2.753708333	1	0.6%
2.744375	1	0.6%
2.74	1	0.6%
2.687604167	1	0.6%
2.671770833	1	0.6%
2.582006944	1	0.6%
2.575625	1	0.6%

velocidad_max
Real number (ℝ)

Distinct	171
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-56.02921

Minimum	-999
Maximum	4.9930556
Zeros	0
Zeros (%)	0.0%
Negative	17
Negative (%)	9.4%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	2.3656771
median	2.8410417
Q3	3.4249306
95-th percentile	3.909375
Maximum	4.9930556
Range	1003.9931
Interquartile range (IQR)	1.0592535

Descriptive statistics

Standard deviation	232.37157
Coefficient of variation (CV)	-4.147329
Kurtosis	12.693508
Mean	-56.02921
Median Absolute Deviation (MAD)	0.55
Skewness	-3.7982036
Sum	-10085.258
Variance	53996.545
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-999	10	5.6%
2.690763889	1	0.6%
3.514513889	1	0.6%
-495.9194444	1	0.6%
3.048194444	1	0.6%
2.650833333	1	0.6%
2.422222222	1	0.6%
1.376180556	1	0.6%
1.782430556	1	0.6%
2.388888889	1	0.6%
Other values (161)	161	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-495.9194444	1	0.6%
-48.69340278	1	0.6%
-24.37902778	1	0.6%
-3.936736111	1	0.6%
-3.084027778	1	0.6%
-1.473333333	1	0.6%
-0.8536805556	1	0.6%
1.231666667	1	0.6%
1.272083333	1	0.6%

Value	Count	Frequency (%)
4.993055556	1	0.6%
4.681458333	1	0.6%
4.515555556	1	0.6%
4.349027778	1	0.6%
4.18	1	0.6%
4.134583333	1	0.6%
4.075347222	1	0.6%
4.015138889	1	0.6%
3.927847222	1	0.6%
3.908402778	1	0.6%

direccion_prom
Real number (ℝ)

Distinct	171
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.374823

Minimum	-999
Maximum	218.19236
Zeros	0
Zeros (%)	0.0%
Negative	11
Negative (%)	6.1%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	109.08299
median	136.2316
Q3	159.21667
95-th percentile	193.29299
Maximum	218.19236
Range	1217.1924
Interquartile range (IQR)	50.133681

Descriptive statistics

Standard deviation	265.70066
Coefficient of variation (CV)	3.7755073
Kurtosis	12.185079
Mean	70.374823
Median Absolute Deviation (MAD)	24.6125
Skewness	-3.6911678
Sum	12667.468
Variance	70596.839
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-999	10	5.6%
84.14166667	1	0.6%
173.2243056	1	0.6%
-419.5256944	1	0.6%
175.8034722	1	0.6%
208.6076389	1	0.6%
199.5472222	1	0.6%
185.8145833	1	0.6%
192.6840278	1	0.6%
191.6965278	1	0.6%
Other values (161)	161	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-419.5256944	1	0.6%
32.75416667	1	0.6%
42.34027778	1	0.6%
54.46111111	1	0.6%
57.62986111	1	0.6%
58.51388889	1	0.6%
66.35208333	1	0.6%
66.93194444	1	0.6%
66.96041667	1	0.6%

Value	Count	Frequency (%)
218.1923611	1	0.6%
214.6555556	1	0.6%
208.6076389	1	0.6%
206.0354167	1	0.6%
204.1854167	1	0.6%
202.4833333	1	0.6%
199.5472222	1	0.6%
197.7840278	1	0.6%
195.4555556	1	0.6%
193.1791667	1	0.6%

direccion_max
Real number (ℝ)

Distinct	171
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	74.356258

Minimum	-999
Maximum	202.66528
Zeros	0
Zeros (%)	0.0%
Negative	11
Negative (%)	6.1%
Memory size	2.8 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	114.85885
median	143.16875
Q3	162.8
95-th percentile	187.22639
Maximum	202.66528
Range	1201.6653
Interquartile range (IQR)	47.941146

Descriptive statistics

Standard deviation	266.46344
Coefficient of variation (CV)	3.5836048
Kurtosis	12.236136
Mean	74.356258
Median Absolute Deviation (MAD)	23.489583
Skewness	-3.703159
Sum	13384.126
Variance	71002.767
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-999	10	5.6%
101.6451389	1	0.6%
170.4083333	1	0.6%
-419.0034722	1	0.6%
173.2416667	1	0.6%
201.39375	1	0.6%
200.6131944	1	0.6%
187.1798611	1	0.6%
189.20625	1	0.6%
188.1104167	1	0.6%
Other values (161)	161	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-999	10	5.6%
-419.0034722	1	0.6%
34.58958333	1	0.6%
45.12152778	1	0.6%
58.35555556	1	0.6%
58.8625	1	0.6%
64.87361111	1	0.6%
67.05972222	1	0.6%
67.57013889	1	0.6%
67.90416667	1	0.6%

Value	Count	Frequency (%)
202.6652778	1	0.6%
201.39375	1	0.6%
200.6131944	1	0.6%
198.9680556	1	0.6%
198.5291667	1	0.6%
197.2097222	1	0.6%
195.1395833	1	0.6%
189.20625	1	0.6%
188.1104167	1	0.6%
187.1798611	1	0.6%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	anio	mes	dia	pm25	codigoserial	dia_semana	estacion	temperatura	humedad	presion	p1	velocidad_prom	velocidad_max	direccion_prom	direccion_max
0	2024	2	1	30.083333	28	Jueves	Estacion Itagui	21.203368	84.515444	0.0000	0.031583	1.911458	2.690764	84.141667	101.645139
1	2024	2	2	36.041667	28	Viernes	Estacion Itagui	21.548194	82.776438	0.0000	0.042090	1.568583	2.275486	158.501389	172.629861
2	2024	2	3	16.166667	28	Sabado	Estacion Itagui	20.828431	83.795549	0.0000	0.023139	1.368840	2.092778	154.681944	161.095833
3	2024	2	4	23.458333	28	Domingo	Estacion Itagui	20.938090	81.345444	0.0000	0.001792	1.157125	1.656389	162.447222	177.250694
4	2024	2	5	29.666667	28	Lunes	Estacion Itagui	20.919458	80.495264	0.0000	0.001521	1.250153	2.090069	189.303472	195.139583
5	2024	2	6	62.375000	28	Martes	Estacion Itagui	21.437403	79.173340	0.0000	0.000000	1.557389	2.386250	160.106944	173.673611
6	2024	2	7	15.750000	28	Miercoles	Estacion Itagui	21.092854	77.957590	-1.3875	-1.387403	0.738597	1.693264	100.135417	116.951389
7	2024	2	8	8.208333	28	Jueves	Estacion Itagui	21.222333	83.440472	0.0000	-6.243708	2.671771	3.758403	82.169444	93.245139
8	2024	2	9	14.833333	28	Viernes	Estacion Itagui	22.632903	78.158500	0.0000	0.000000	2.575625	3.718194	90.926389	102.394444
9	2024	2	10	18.083333	28	Sabado	Estacion Itagui	23.945389	73.589569	0.0000	0.000007	2.310493	3.459514	108.813194	129.338194

	anio	mes	dia	pm25	codigoserial	dia_semana	estacion	festivo	temperatura	humedad	presion	p1	velocidad_prom	velocidad_max	direccion_prom	direccion_max
50	2024	3	22	3779.235616	86	Viernes	Estacion Aranjuez	0	23.666250	59.241944	848.580556	-1.387500	0.037569	1.231667	175.651389	168.935417
51	2024	3	23	4202.691975	86	Sabado	Estacion Aranjuez	0	24.466528	66.774931	851.537014	0.000000	2.012917	3.691806	195.455556	175.600000
52	2024	3	24	4197.213650	86	Domingo	Estacion Aranjuez	0	24.469722	65.367500	851.030556	0.000000	1.711667	3.078056	146.755556	144.386111
53	2024	3	25	27.402062	86	Lunes	Estacion Aranjuez	1	24.338403	61.306250	851.541667	0.000069	1.561597	2.834583	168.268056	158.643056
54	2024	3	26	7524.074892	86	Martes	Estacion Aranjuez	0	23.391319	58.621875	850.758403	-0.693750	1.060903	2.531111	172.701389	163.200000
55	2024	3	27	40.513067	86	Miercoles	Estacion Aranjuez	0	23.061111	64.514722	852.781181	0.000007	1.753403	3.166944	214.655556	198.529167
56	2024	3	28	34.303346	86	Jueves	Estacion Aranjuez	1	24.025278	63.482431	852.814097	0.000000	1.977708	3.635903	175.940972	171.405556
57	2024	3	29	-389.206004	86	Viernes	Estacion Aranjuez	1	23.458819	65.010208	852.446458	0.000035	1.929583	3.559375	174.241667	173.286806
58	2024	3	30	33.911246	86	Sabado	Estacion Aranjuez	0	23.629167	65.643403	851.854097	0.000000	1.952778	3.571667	169.008333	168.874306
59	2024	3	31	41.063325	86	Domingo	Estacion Aranjuez	0	21.602708	78.103958	852.681875	0.001333	1.458681	2.623889	139.196528	142.368056

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)